www.gusucode.com > 茶都拼客网全功能版 8 > 茶都拼客网全功能版 8.8源码程序/teasdxmccom/茶都拼客网V8.8（全功能，无限制，完全开源）/Ku_type/Index_tjShangjia.asp

    <%

set rsmai=server.CreateObject("adodb.recordset")
sqlmai="select top 5 * from [shangjia] where shenhe=1 and xinyu=2 order by addtime desc"
rsmai.open sqlmai,conn,1,1


%>
<div align="center">
	<table border="0" width="137" height="121" cellpadding="0" cellspacing="0">
	<%if Rsmai.eof or Rsmai.bof then%>
		<tr>
			<td height="121" width="137">
			<p align="center">暂无推荐的VIP商家</td>
		</tr>
	<%
	else
	%>	
	<tr>
			<%do while not rsmai.eof%>
			<td height="141" width="137">

<div align="center">

<table border="0" width="145" height="139" cellpadding="0" cellspacing="1"  >
	<tr>
		<td height="107" width="135" style="border: 1px solid #D0D4D9" align="center">
		<a href="My_shop.asp?guxing=<%=rsmai("id")%>">
		<img border="0" src="<%if rsmai("logo")<>"" then%><%=rsmai("logo")%><%else%>ku_Img/nopic120-90.gif<%end if%>" width="126" height="99" alt="店铺名称：<%=rsmai("name")%>&#13&#10创建时间：<%=rsmai("addtime")%>&#13&#10联系人：<%=rsmai("username")%>"></a></td>
		<td height="107" width="5">　</td>
	</tr>
	<tr>
		<td height="29" width="137" align=center><b>商家</b>：<a href="My_shop.asp?guxing=<%=rsmai("id")%>" title="店铺名称：<%=rsmai("name")%>&#13&#10创建时间：<%=rsmai("addtime")%>&#13&#10联系人：<%=rsmai("username")%>"><%=left(rsmai("name"),7) %></a></td>
		<td height="29" width="5" >　</td>
	</tr>
</table></div>
			</td>
			<% 
    rsmai.movenext  
    loop
    Rsmai.Close
    Set Rsmai=Nothing
    
%><%end if%>
		</tr>

	</table>
</div>